home *** CD-ROM | disk | FTP | other *** search
/ Amiga Tools 2 / Amiga Tools 2.iso / datenbanken / db2.4 / examples / arexxdemos / timefield.db < prev    next >
Text File  |  1995-03-09  |  281b  |  12 lines

  1. /* Rexxprogram for db to convert a field to a "time field".
  2.  * By Anders Callertun 1994
  3.  */
  4.  
  5. options results
  6. GETFIELD
  7. time = result
  8. if pos(':',time)=0 & length(time)<5 then do
  9.     if length(time)<3 then time = right(time,3,'0')
  10.     PUTFIELD left(time,length(time)-2)':'right(time,2)
  11. end
  12.